﻿CREATE TABLE [dbo].[Bus_Route] (
    [routeno]         NVARCHAR (10) NULL,
    [roundno]         SMALLINT      NOT NULL,
    [bus_id]          NVARCHAR (10) NULL,
    [d_id]            NVARCHAR (6)  NULL,
    [c_id]            NVARCHAR (6)  NULL,
    [max_student]     SMALLINT      NULL,
    [alloted_student] SMALLINT      NULL,
    [departure_in]    NVARCHAR (15) NULL,
    [start_time]      NVARCHAR (10) NULL,
    [end_time]        NVARCHAR (10) NULL
);

